package com.h3c.nem.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.h3c.nem.entity.SdFileTemplate;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/**
 * Copyright (C), 2020-2020, h3c
 * FileName: SdFileTemplateMapper
 *
 * @Author: l22886
 * @Date: 2022-01-19
 * Description: sd_file_template mapper
 * Version: 1.0
 */
public interface SdFileTemplateMapper extends BaseMapper<SdFileTemplate> {


    /**
     * @title: queryListByFuzzy
     * @description: 模糊列表查询
     * @params: [ SdFileTemplate ]
     * @return: java.util.List
     * @createTime: 2021-06-16
     * @version: 1.0
     * @author: l22886
     */
    public List<SdFileTemplate> queryListByFuzzy(SdFileTemplate SdFileTemplate);

    @Select(" select * from sd_file_template where template_name = #{templateName} or template_code = #{templateCode} ")
    public List<SdFileTemplate> queryFileTemplateList(String templateName,String templateCode);

    /**
     * @title: queryListByFuzzy
     * @description: 精确列表查询
     * @params: [ SdFileTemplate ]
     * @return: java.util.List
     * @createTime: 2021-06-16
     * @version: 1.0
     * @author: l22886
     */
    public List<SdFileTemplate> queryList(SdFileTemplate SdFileTemplate);

    /**
     * @title: updateSdFileTemplate
     * @description: 更新
     * @params: [ SdFileTemplate ]
     * @return: java.lang.Integer
     * @createTime: 2021-06-16
     * @version: 1.0
     * @author: l22886
     */
    public Integer updateSdFileTemplate(SdFileTemplate SdFileTemplate);

    /**
     * @title: insertSdFileTemplate
     * @description: 插入
     * @params: [ SdFileTemplate ]
     * @return: java.lang.Integer
     * @createTime: 2021-06-16
     * @version: 1.0
     * @author: l22886
     */
    public Integer insertSdFileTemplate(SdFileTemplate SdFileTemplate);

    /**
     * @title: deleteSdFileTemplate
     * @description: 删除
     * @params: [ SdFileTemplate ]
     * @return: java.lang.Integer
     * @createTime: 2021-06-16
     * @version: 1.0
     * @author: l22886
     */
    public Integer deleteSdFileTemplate(SdFileTemplate SdFileTemplate);
}
